Dataset statistics
| Number of variables | 30 |
|---|---|
| Number of observations | 19587643 |
| Missing cells | 17325047 |
| Missing cells (%) | 2.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 17.8 GiB |
| Average record size in memory | 973.1 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 11 |
| DateTime | 9 |
| Unsupported | 1 |
videoamp_household_id has a high cardinality: 881661 distinct values | High cardinality |
tms_id has a high cardinality: 5535 distinct values | High cardinality |
ad_content_title has a high cardinality: 2204 distinct values | High cardinality |
series_name has a high cardinality: 2280 distinct values | High cardinality |
episode_title has a high cardinality: 2626 distinct values | High cardinality |
network has a high cardinality: 79 distinct values | High cardinality |
callsign has a high cardinality: 1274 distinct values | High cardinality |
market_name has a high cardinality: 210 distinct values | High cardinality |
season_number is highly correlated with episode_number | High correlation |
episode_number is highly correlated with season_number | High correlation |
timeshift_name is highly correlated with timeshift_seconds | High correlation |
ad_id is highly correlated with network and 1 other fields | High correlation |
session_duration_seconds is highly correlated with program_duration_seconds | High correlation |
timeshift_seconds is highly correlated with timeshift_name | High correlation |
program_duration_seconds is highly correlated with session_duration_seconds and 2 other fields | High correlation |
season_number is highly correlated with network and 1 other fields | High correlation |
network is highly correlated with ad_id and 3 other fields | High correlation |
media_group is highly correlated with ad_id and 3 other fields | High correlation |
media_group is highly correlated with network | High correlation |
ad_id is highly correlated with network | High correlation |
network is highly correlated with media_group and 1 other fields | High correlation |
ad_content_title has 3089626 (15.8%) missing values | Missing |
episode_title has 6763657 (34.5%) missing values | Missing |
season_number has 3089626 (15.8%) missing values | Missing |
episode_number has 3089626 (15.8%) missing values | Missing |
full_panel_intab_weekly_weight has 1135274 (5.8%) missing values | Missing |
videoamp_event_key has unique values | Unique |
airing_date_utc is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
season_number has 3544177 (18.1%) zeros | Zeros |
episode_number has 3632098 (18.5%) zeros | Zeros |
timeshift_seconds has 13628575 (69.6%) zeros | Zeros |
east_coast_offset_seconds has 16423654 (83.8%) zeros | Zeros |
Reproduction
| Analysis started | 2021-08-26 21:31:07.642385 |
|---|---|
| Analysis finished | 2021-08-26 22:54:30.689287 |
| Duration | 1 hour, 23 minutes and 23.05 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
| Distinct | 19587643 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98031599.73 |
| Minimum | 6 |
|---|---|
| Maximum | 200243140 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.4 MiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 9785912.9 |
| Q1 | 49015580 |
| median | 98017669 |
| Q3 | 147047606 |
| 95-th percentile | 186302756.4 |
| Maximum | 200243140 |
| Range | 200243134 |
| Interquartile range (IQR) | 98032026 |
Descriptive statistics
| Standard deviation | 56616646.33 |
|---|---|
| Coefficient of variation (CV) | 0.5775346571 |
| Kurtosis | -1.198638944 |
| Mean | 98031599.73 |
| Median Absolute Deviation (MAD) | 49015234 |
| Skewness | 0.001181276093 |
| Sum | 1.920207978 × 1015 |
| Variance | 3.205444642 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 58862436 | 1 | < 0.1% |
| 9783290 | 1 | < 0.1% |
| 131428351 | 1 | < 0.1% |
| 174757888 | 1 | < 0.1% |
| 137007105 | 1 | < 0.1% |
| 44728323 | 1 | < 0.1% |
| 23771140 | 1 | < 0.1% |
| 120238085 | 1 | < 0.1% |
| 162177031 | 1 | < 0.1% |
| 40556552 | 1 | < 0.1% |
| Other values (19587633) | 19587633 |
| Value | Count | Frequency (%) |
| 6 | 1 | |
| 14 | 1 | |
| 24 | 1 | |
| 29 | 1 | |
| 35 | 1 | |
| 50 | 1 | |
| 59 | 1 | |
| 70 | 1 | |
| 75 | 1 | |
| 93 | 1 |
| Value | Count | Frequency (%) |
| 200243140 | 1 | |
| 200238340 | 1 | |
| 200238180 | 1 | |
| 200236900 | 1 | |
| 200236740 | 1 | |
| 200236260 | 1 | |
| 200226020 | 1 | |
| 200225860 | 1 | |
| 200225700 | 1 | |
| 200225540 | 1 |
| Distinct | 881661 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 GiB |
| d267de3041ff24c584024b2e8f3754e87038b7ef15c3d1bb5d5aaed94f1ccc24 | 670 |
|---|---|
| e7a2f8b72cdbb001ffec170e31ed010c37d7beaef83e74aa5524bb272712200b | 634 |
| 3b8a097674dc6199ee33d17d3787bddc492859d3e9b78646c8843d0747a7e3b7 | 593 |
| 92287542743d01f1de30a8f5c7977056530192c8ea8a0105fac93011f6b9af80 | 565 |
| 7bef78e89dc506c631bdd030481911a403338110e657dc5cc5bdb196117d5a5a | 543 |
| Other values (881656) |
Length
| Max length | 64 |
|---|---|
| Median length | 64 |
| Mean length | 64 |
| Min length | 64 |
Characters and Unicode
| Total characters | 1253609152 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 108478 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | 004c25ab7f5c7914440b6e9b4574ca804a077af28c9d03b2fe8472c29e3db0e1 |
|---|---|
| 2nd row | 004c25ab7f5c7914440b6e9b4574ca804a077af28c9d03b2fe8472c29e3db0e1 |
| 3rd row | 004c25ab7f5c7914440b6e9b4574ca804a077af28c9d03b2fe8472c29e3db0e1 |
| 4th row | 004c25ab7f5c7914440b6e9b4574ca804a077af28c9d03b2fe8472c29e3db0e1 |
| 5th row | 006bf297c0caed8e12fb5f9bcf3f53dc4a63dde1aaa57a875f5a15dc4c74753f |
Common Values
| Value | Count | Frequency (%) |
| d267de3041ff24c584024b2e8f3754e87038b7ef15c3d1bb5d5aaed94f1ccc24 | 670 | < 0.1% |
| e7a2f8b72cdbb001ffec170e31ed010c37d7beaef83e74aa5524bb272712200b | 634 | < 0.1% |
| 3b8a097674dc6199ee33d17d3787bddc492859d3e9b78646c8843d0747a7e3b7 | 593 | < 0.1% |
| 92287542743d01f1de30a8f5c7977056530192c8ea8a0105fac93011f6b9af80 | 565 | < 0.1% |
| 7bef78e89dc506c631bdd030481911a403338110e657dc5cc5bdb196117d5a5a | 543 | < 0.1% |
| 3d75508b22d5385a51a45acadceb62bca14e05b1a6e37eebbea17d212b4618b8 | 523 | < 0.1% |
| b2d8aa7913060601fce1fcf723da8e5434acfde46f1acfb7341a85427667e4c6 | 507 | < 0.1% |
| b51309fc62ea919a79391b4a26bfcfeedcfd44f43982b939e874a4e4ea71c082 | 502 | < 0.1% |
| 0545e3f198c0d56a524c56dbe9edd400de65e93dbc29ae1061879a88b110fecd | 493 | < 0.1% |
| d0cf782adf480552a7ba4fa1098194eead8926044e23dc6a0800ac9fdbb11185 | 482 | < 0.1% |
| Other values (881651) | 19582131 |
Length
| Value | Count | Frequency (%) |
| d267de3041ff24c584024b2e8f3754e87038b7ef15c3d1bb5d5aaed94f1ccc24 | 670 | < 0.1% |
| e7a2f8b72cdbb001ffec170e31ed010c37d7beaef83e74aa5524bb272712200b | 634 | < 0.1% |
| 3b8a097674dc6199ee33d17d3787bddc492859d3e9b78646c8843d0747a7e3b7 | 593 | < 0.1% |
| 92287542743d01f1de30a8f5c7977056530192c8ea8a0105fac93011f6b9af80 | 565 | < 0.1% |
| 7bef78e89dc506c631bdd030481911a403338110e657dc5cc5bdb196117d5a5a | 543 | < 0.1% |
| 3d75508b22d5385a51a45acadceb62bca14e05b1a6e37eebbea17d212b4618b8 | 523 | < 0.1% |
| b2d8aa7913060601fce1fcf723da8e5434acfde46f1acfb7341a85427667e4c6 | 507 | < 0.1% |
| b51309fc62ea919a79391b4a26bfcfeedcfd44f43982b939e874a4e4ea71c082 | 502 | < 0.1% |
| 0545e3f198c0d56a524c56dbe9edd400de65e93dbc29ae1061879a88b110fecd | 493 | < 0.1% |
| d0cf782adf480552a7ba4fa1098194eead8926044e23dc6a0800ac9fdbb11185 | 482 | < 0.1% |
| Other values (881651) | 19582131 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 78510038 | 6.3% |
| 2 | 78438081 | 6.3% |
| 4 | 78426048 | 6.3% |
| d | 78401508 | 6.3% |
| 9 | 78390812 | 6.3% |
| e | 78387873 | 6.3% |
| 0 | 78361082 | 6.3% |
| 7 | 78352502 | 6.3% |
| 1 | 78345278 | 6.2% |
| 5 | 78343081 | 6.2% |
| Other values (6) | 469652849 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 783593033 | |
| Lowercase Letter | 470016119 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 78438081 | |
| 4 | 78426048 | |
| 9 | 78390812 | |
| 0 | 78361082 | |
| 7 | 78352502 | |
| 1 | 78345278 | |
| 5 | 78343081 | |
| 6 | 78342408 | |
| 8 | 78315604 | |
| 3 | 78278137 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 78510038 | |
| d | 78401508 | |
| e | 78387873 | |
| f | 78296535 | |
| c | 78259720 | |
| b | 78160445 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 783593033 | |
| Latin | 470016119 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 78438081 | |
| 4 | 78426048 | |
| 9 | 78390812 | |
| 0 | 78361082 | |
| 7 | 78352502 | |
| 1 | 78345278 | |
| 5 | 78343081 | |
| 6 | 78342408 | |
| 8 | 78315604 | |
| 3 | 78278137 |
Latin
| Value | Count | Frequency (%) |
| a | 78510038 | |
| d | 78401508 | |
| e | 78387873 | |
| f | 78296535 | |
| c | 78259720 | |
| b | 78160445 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1253609152 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 78510038 | 6.3% |
| 2 | 78438081 | 6.3% |
| 4 | 78426048 | 6.3% |
| d | 78401508 | 6.3% |
| 9 | 78390812 | 6.3% |
| e | 78387873 | 6.3% |
| 0 | 78361082 | 6.3% |
| 7 | 78352502 | 6.3% |
| 1 | 78345278 | 6.2% |
| 5 | 78343081 | 6.2% |
| Other values (6) | 469652849 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 GiB |
| LLTR0095000H | |
|---|---|
| LLTR0093000H | |
| LLTR0084000H | 226985 |
| LLTR0099000H | 35226 |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Characters and Unicode
| Total characters | 235051716 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LLTR0093000H |
|---|---|
| 2nd row | LLTR0095000H |
| 3rd row | LLTR0095000H |
| 4th row | LLTR0095000H |
| 5th row | LLTR0095000H |
Common Values
| Value | Count | Frequency (%) |
| LLTR0095000H | 15452628 | |
| LLTR0093000H | 3872804 | 19.8% |
| LLTR0084000H | 226985 | 1.2% |
| LLTR0099000H | 35226 | 0.2% |
Length
Pie chart
| Value | Count | Frequency (%) |
| lltr0095000h | 15452628 | |
| lltr0093000h | 3872804 | 19.8% |
| lltr0084000h | 226985 | 1.2% |
| lltr0099000h | 35226 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 97938215 | |
| L | 39175286 | 16.7% |
| T | 19587643 | 8.3% |
| R | 19587643 | 8.3% |
| H | 19587643 | 8.3% |
| 9 | 19395884 | 8.3% |
| 5 | 15452628 | 6.6% |
| 3 | 3872804 | 1.6% |
| 8 | 226985 | 0.1% |
| 4 | 226985 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 137113501 | |
| Uppercase Letter | 97938215 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 97938215 | |
| 9 | 19395884 | 14.1% |
| 5 | 15452628 | 11.3% |
| 3 | 3872804 | 2.8% |
| 8 | 226985 | 0.2% |
| 4 | 226985 | 0.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 39175286 | |
| T | 19587643 | |
| R | 19587643 | |
| H | 19587643 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 137113501 | |
| Latin | 97938215 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 97938215 | |
| 9 | 19395884 | 14.1% |
| 5 | 15452628 | 11.3% |
| 3 | 3872804 | 2.8% |
| 8 | 226985 | 0.2% |
| 4 | 226985 | 0.2% |
Latin
| Value | Count | Frequency (%) |
| L | 39175286 | |
| T | 19587643 | |
| R | 19587643 | |
| H | 19587643 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 235051716 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 97938215 | |
| L | 39175286 | 16.7% |
| T | 19587643 | 8.3% |
| R | 19587643 | 8.3% |
| H | 19587643 | 8.3% |
| 9 | 19395884 | 8.3% |
| 5 | 15452628 | 6.6% |
| 3 | 3872804 | 1.6% |
| 8 | 226985 | 0.1% |
| 4 | 226985 | 0.1% |
ad_start_utc
Date
| Distinct | 14481 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.4 MiB |
| Minimum | 2020-12-14 00:20:40 |
|---|---|
| Maximum | 2021-03-22 00:26:10 |
ad_end_utc
Date
| Distinct | 14601 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.4 MiB |
| Minimum | 2020-12-14 00:21:42 |
|---|---|
| Maximum | 2021-03-22 00:27:11 |
ad_duration_seconds
Real number (ℝ≥0)
| Distinct | 62 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.64945486 |
| Minimum | 4 |
|---|---|
| Maximum | 121 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.4 MiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 60 |
| median | 60 |
| Q3 | 61 |
| 95-th percentile | 62 |
| Maximum | 121 |
| Range | 117 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 16.46449462 |
|---|---|
| Coefficient of variation (CV) | 0.3012746359 |
| Kurtosis | 4.794630049 |
| Mean | 54.64945486 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -2.568362935 |
| Sum | 1070454012 |
| Variance | 271.079583 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 60 | 6600928 | |
| 61 | 5103672 | |
| 62 | 3187452 | |
| 59 | 1588640 | 8.1% |
| 4 | 1170472 | 6.0% |
| 57 | 244137 | 1.2% |
| 5 | 214837 | 1.1% |
| 58 | 193652 | 1.0% |
| 53 | 180324 | 0.9% |
| 21 | 136401 | 0.7% |
| Other values (52) | 967128 | 4.9% |
| Value | Count | Frequency (%) |
| 4 | 1170472 | |
| 5 | 214837 | 1.1% |
| 6 | 59154 | 0.3% |
| 7 | 132475 | 0.7% |
| 8 | 51957 | 0.3% |
| 9 | 57333 | 0.3% |
| 10 | 7152 | < 0.1% |
| 11 | 11384 | 0.1% |
| 12 | 53619 | 0.3% |
| 13 | 11147 | 0.1% |
| Value | Count | Frequency (%) |
| 121 | 60 | < 0.1% |
| 120 | 132 | < 0.1% |
| 96 | 33 | < 0.1% |
| 67 | 4569 | < 0.1% |
| 65 | 475 | < 0.1% |
| 62 | 3187452 | |
| 61 | 5103672 | |
| 60 | 6600928 | |
| 59 | 1588640 | 8.1% |
| 58 | 193652 | 1.0% |
| Distinct | 5535 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 GiB |
| EP000031282865 | 359053 |
|---|---|
| EP035115960001 | 143541 |
| EP000031282860 | 86058 |
| EP000031282862 | 83705 |
| SH003248290000 | 76715 |
| Other values (5530) |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Characters and Unicode
| Total characters | 274227002 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | EP026844840948 |
|---|---|
| 2nd row | EP000000351549 |
| 3rd row | EP000000351549 |
| 4th row | EP015057882387 |
| 5th row | MV015471150000 |
Common Values
| Value | Count | Frequency (%) |
| EP000031282865 | 359053 | 1.8% |
| EP035115960001 | 143541 | 0.7% |
| EP000031282860 | 86058 | 0.4% |
| EP000031282862 | 83705 | 0.4% |
| SH003248290000 | 76715 | 0.4% |
| EP005000800516 | 75072 | 0.4% |
| EP000031282837 | 74439 | 0.4% |
| SH000191310000 | 71658 | 0.4% |
| SH008776990000 | 69467 | 0.4% |
| SH037749320000 | 66495 | 0.3% |
| Other values (5525) | 18481440 |
Length
| Value | Count | Frequency (%) |
| ep000031282865 | 359053 | 1.8% |
| ep035115960001 | 143541 | 0.7% |
| ep000031282860 | 86058 | 0.4% |
| ep000031282862 | 83705 | 0.4% |
| sh003248290000 | 76715 | 0.4% |
| ep005000800516 | 75072 | 0.4% |
| ep000031282837 | 74439 | 0.4% |
| sh000191310000 | 71658 | 0.4% |
| sh008776990000 | 69467 | 0.4% |
| sh037749320000 | 66495 | 0.3% |
| Other values (5525) | 18481440 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 73001403 | |
| 1 | 27193829 | 9.9% |
| 2 | 21909194 | 8.0% |
| 3 | 20297662 | 7.4% |
| 5 | 19140675 | 7.0% |
| E | 16846538 | 6.1% |
| P | 16846538 | 6.1% |
| 8 | 15885906 | 5.8% |
| 4 | 15395780 | 5.6% |
| 9 | 15050241 | 5.5% |
| Other values (6) | 32659236 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 235051716 | |
| Uppercase Letter | 39175286 | 14.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 73001403 | |
| 1 | 27193829 | 11.6% |
| 2 | 21909194 | 9.3% |
| 3 | 20297662 | 8.6% |
| 5 | 19140675 | 8.1% |
| 8 | 15885906 | 6.8% |
| 4 | 15395780 | 6.5% |
| 9 | 15050241 | 6.4% |
| 6 | 14362231 | 6.1% |
| 7 | 12814795 | 5.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 16846538 | |
| P | 16846538 | |
| S | 1719460 | 4.4% |
| H | 1719460 | 4.4% |
| M | 1021645 | 2.6% |
| V | 1021645 | 2.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 235051716 | |
| Latin | 39175286 | 14.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 73001403 | |
| 1 | 27193829 | 11.6% |
| 2 | 21909194 | 9.3% |
| 3 | 20297662 | 8.6% |
| 5 | 19140675 | 8.1% |
| 8 | 15885906 | 6.8% |
| 4 | 15395780 | 6.5% |
| 9 | 15050241 | 6.4% |
| 6 | 14362231 | 6.1% |
| 7 | 12814795 | 5.5% |
Latin
| Value | Count | Frequency (%) |
| E | 16846538 | |
| P | 16846538 | |
| S | 1719460 | 4.4% |
| H | 1719460 | 4.4% |
| M | 1021645 | 2.6% |
| V | 1021645 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 274227002 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 73001403 | |
| 1 | 27193829 | 9.9% |
| 2 | 21909194 | 8.0% |
| 3 | 20297662 | 7.4% |
| 5 | 19140675 | 7.0% |
| E | 16846538 | 6.1% |
| P | 16846538 | 6.1% |
| 8 | 15885906 | 5.8% |
| 4 | 15395780 | 5.6% |
| 9 | 15050241 | 5.5% |
| Other values (6) | 32659236 |
| Distinct | 2204 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3089626 |
| Missing (%) | 15.8% |
| Memory size | 1.3 GiB |
| Today | 995486 |
|---|---|
| Good Morning America | 984661 |
| CBS This Morning | 835435 |
| NFL Football | 658048 |
| NBC Nightly News With Lester Holt | 570676 |
| Other values (2199) |
Length
| Max length | 88 |
|---|---|
| Median length | 17 |
| Mean length | 18.57859584 |
| Min length | 2 |
Characters and Unicode
| Total characters | 306509990 |
|---|---|
| Distinct characters | 85 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Live with Kelly and Ryan |
|---|---|
| 2nd row | 60 Minutes |
| 3rd row | 60 Minutes |
| 4th row | CBS This Morning |
| 5th row | Unlocking Christmas |
Common Values
| Value | Count | Frequency (%) |
| Today | 995486 | 5.1% |
| Good Morning America | 984661 | 5.0% |
| CBS This Morning | 835435 | 4.3% |
| NFL Football | 658048 | 3.4% |
| NBC Nightly News With Lester Holt | 570676 | 2.9% |
| The Price Is Right | 515097 | 2.6% |
| ABC World News Tonight With David Muir | 439525 | 2.2% |
| Wheel of Fortune | 305716 | 1.6% |
| The Young and the Restless | 211680 | 1.1% |
| The Bachelor | 209444 | 1.1% |
| Other values (2194) | 10772249 | |
| (Missing) | 3089626 | 15.8% |
Length
| Value | Count | Frequency (%) |
| the | 3485167 | 6.4% |
| with | 2461555 | 4.5% |
| news | 2401998 | 4.4% |
| morning | 2385880 | 4.4% |
| today | 1693126 | 3.1% |
| cbs | 1441864 | 2.6% |
| america | 1136279 | 2.1% |
| good | 1123404 | 2.1% |
| this | 1044212 | 1.9% |
| nfl | 737424 | 1.3% |
| Other values (2282) | 36818171 |
Most occurring characters
| Value | Count | Frequency (%) |
| 38231063 | 12.5% | |
| e | 24698065 | 8.1% |
| o | 19684643 | 6.4% |
| i | 18708086 | 6.1% |
| a | 15401742 | 5.0% |
| n | 15313433 | 5.0% |
| t | 14606646 | 4.8% |
| r | 14284158 | 4.7% |
| h | 11948706 | 3.9% |
| s | 11493379 | 3.7% |
| Other values (75) | 122140069 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 200637734 | |
| Uppercase Letter | 60696879 | 19.8% |
| Space Separator | 38231063 | 12.5% |
| Decimal Number | 3742372 | 1.2% |
| Other Punctuation | 3001456 | 1.0% |
| Dash Punctuation | 171276 | 0.1% |
| Open Punctuation | 14163 | < 0.1% |
| Close Punctuation | 14163 | < 0.1% |
| Math Symbol | 884 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 24698065 | |
| o | 19684643 | |
| i | 18708086 | |
| a | 15401742 | 7.7% |
| n | 15313433 | 7.6% |
| t | 14606646 | 7.3% |
| r | 14284158 | 7.1% |
| h | 11948706 | 6.0% |
| s | 11493379 | 5.7% |
| l | 10306676 | 5.1% |
| Other values (22) | 44192200 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 6893639 | |
| N | 5980219 | 9.9% |
| M | 4955219 | 8.2% |
| C | 4669336 | 7.7% |
| W | 4590591 | 7.6% |
| B | 4551627 | 7.5% |
| S | 3800548 | 6.3% |
| F | 3662406 | 6.0% |
| A | 3207819 | 5.3% |
| L | 2691773 | 4.4% |
| Other values (17) | 15693702 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 1075574 | |
| ' | 683710 | |
| . | 575625 | |
| & | 268306 | 8.9% |
| , | 187110 | 6.2% |
| ! | 171568 | 5.7% |
| ¡ | 18617 | 0.6% |
| / | 12108 | 0.4% |
| ? | 8335 | 0.3% |
| # | 483 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 882808 | |
| 3 | 674712 | |
| 1 | 462259 | |
| 6 | 454364 | |
| 5 | 362389 | |
| 4 | 310966 | 8.3% |
| 2 | 299622 | 8.0% |
| 8 | 114963 | 3.1% |
| 7 | 108414 | 2.9% |
| 9 | 71875 | 1.9% |
Space Separator
| Value | Count | Frequency (%) |
| 38231063 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 171276 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 884 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 14163 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 14163 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 261334613 | |
| Common | 45175377 | 14.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 24698065 | 9.5% |
| o | 19684643 | 7.5% |
| i | 18708086 | 7.2% |
| a | 15401742 | 5.9% |
| n | 15313433 | 5.9% |
| t | 14606646 | 5.6% |
| r | 14284158 | 5.5% |
| h | 11948706 | 4.6% |
| s | 11493379 | 4.4% |
| l | 10306676 | 3.9% |
| Other values (49) | 104889079 |
Common
| Value | Count | Frequency (%) |
| 38231063 | ||
| : | 1075574 | 2.4% |
| 0 | 882808 | 2.0% |
| ' | 683710 | 1.5% |
| 3 | 674712 | 1.5% |
| . | 575625 | 1.3% |
| 1 | 462259 | 1.0% |
| 6 | 454364 | 1.0% |
| 5 | 362389 | 0.8% |
| 4 | 310966 | 0.7% |
| Other values (16) | 1461907 | 3.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 306430443 | |
| Latin 1 Sup | 79547 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 38231063 | 12.5% | |
| e | 24698065 | 8.1% |
| o | 19684643 | 6.4% |
| i | 18708086 | 6.1% |
| a | 15401742 | 5.0% |
| n | 15313433 | 5.0% |
| t | 14606646 | 4.8% |
| r | 14284158 | 4.7% |
| h | 11948706 | 3.9% |
| s | 11493379 | 3.8% |
| Other values (67) | 122060522 |
Latin 1 Sup
| Value | Count | Frequency (%) |
| ó | 22935 | |
| é | 21837 | |
| ¡ | 18617 | |
| í | 14939 | |
| á | 644 | 0.8% |
| ñ | 437 | 0.5% |
| Á | 122 | 0.2% |
| ú | 16 | < 0.1% |
| Distinct | 3207 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.4 MiB |
| Minimum | 2020-12-14 00:00:00 |
|---|---|
| Maximum | 2021-03-22 00:00:00 |
| Distinct | 17662 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2761.41633 |
| Minimum | 1 |
|---|---|
| Maximum | 28800 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 63 |
| Q1 | 1376 |
| median | 2430 |
| Q3 | 3600 |
| 95-th percentile | 7200 |
| Maximum | 28800 |
| Range | 28799 |
| Interquartile range (IQR) | 2224 |
Descriptive statistics
| Standard deviation | 2076.39977 |
|---|---|
| Coefficient of variation (CV) | 0.7519328933 |
| Kurtosis | 4.407985176 |
| Mean | 2761.41633 |
| Median Absolute Deviation (MAD) | 1170 |
| Skewness | 1.448622205 |
| Sum | 5.408963724 × 1010 |
| Variance | 4311436.006 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3600 | 2277101 | 11.6% |
| 1800 | 956911 | 4.9% |
| 7200 | 720136 | 3.7% |
| 3599 | 347381 | 1.8% |
| 1799 | 139103 | 0.7% |
| 5400 | 62270 | 0.3% |
| 3598 | 58515 | 0.3% |
| 7199 | 48045 | 0.2% |
| 3586 | 44803 | 0.2% |
| 3587 | 44501 | 0.2% |
| Other values (17652) | 14888877 |
| Value | Count | Frequency (%) |
| 1 | 29718 | |
| 2 | 34741 | |
| 3 | 21504 | |
| 4 | 15053 | |
| 5 | 29301 | |
| 6 | 30294 | |
| 7 | 28972 | |
| 8 | 24633 | |
| 9 | 23361 | |
| 10 | 22329 |
| Value | Count | Frequency (%) |
| 28800 | 143 | |
| 28799 | 227 | |
| 28798 | 42 | < 0.1% |
| 28797 | 14 | < 0.1% |
| 28795 | 2 | < 0.1% |
| 28794 | 3 | < 0.1% |
| 28792 | 2 | < 0.1% |
| 28791 | 2 | < 0.1% |
| 28789 | 1 | < 0.1% |
| 28788 | 1 | < 0.1% |
| Distinct | 2567463 |
|---|---|
| Distinct (%) | 13.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.4 MiB |
| Minimum | 2020-12-14 00:00:00 |
|---|---|
| Maximum | 2021-03-22 00:18:35 |
session_end_utc
Date
| Distinct | 1996336 |
|---|---|
| Distinct (%) | 10.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.4 MiB |
| Minimum | 2020-12-14 00:20:41 |
|---|---|
| Maximum | 2021-03-22 01:00:00 |
| Distinct | 3478 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.4 MiB |
| Minimum | 2020-12-14 00:00:00 |
|---|---|
| Maximum | 2021-03-21 23:30:00 |
program_end_utc
Date
| Distinct | 3578 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.4 MiB |
| Minimum | 2020-12-14 01:00:00 |
|---|---|
| Maximum | 2021-03-22 01:00:00 |
| Distinct | 118 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4784.301385 |
| Minimum | 600 |
|---|---|
| Maximum | 28800 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.4 MiB |
Quantile statistics
| Minimum | 600 |
|---|---|
| 5-th percentile | 1800 |
| Q1 | 3600 |
| median | 3600 |
| Q3 | 7200 |
| 95-th percentile | 10800 |
| Maximum | 28800 |
| Range | 28200 |
| Interquartile range (IQR) | 3600 |
Descriptive statistics
| Standard deviation | 2804.009865 |
|---|---|
| Coefficient of variation (CV) | 0.5860855409 |
| Kurtosis | 4.790304991 |
| Mean | 4784.301385 |
| Median Absolute Deviation (MAD) | 1500 |
| Skewness | 1.66782386 |
| Sum | 9.371318754 × 1010 |
| Variance | 7862471.325 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3600 | 9245843 | |
| 7200 | 4293838 | |
| 1800 | 3266695 | 16.7% |
| 12600 | 524797 | 2.7% |
| 5400 | 347652 | 1.8% |
| 10800 | 340649 | 1.7% |
| 3660 | 191131 | 1.0% |
| 7260 | 186941 | 1.0% |
| 9000 | 164990 | 0.8% |
| 14400 | 151459 | 0.8% |
| Other values (108) | 873648 | 4.5% |
| Value | Count | Frequency (%) |
| 600 | 215 | < 0.1% |
| 900 | 918 | < 0.1% |
| 1080 | 33 | < 0.1% |
| 1140 | 9 | < 0.1% |
| 1200 | 57 | < 0.1% |
| 1380 | 467 | < 0.1% |
| 1440 | 5037 | |
| 1500 | 6768 | |
| 1560 | 586 | < 0.1% |
| 1620 | 273 | < 0.1% |
| Value | Count | Frequency (%) |
| 28800 | 9961 | 0.1% |
| 25200 | 1808 | < 0.1% |
| 21600 | 12283 | 0.1% |
| 18000 | 3801 | < 0.1% |
| 16200 | 3260 | < 0.1% |
| 15780 | 12 | < 0.1% |
| 14400 | 151459 | |
| 14280 | 1 | < 0.1% |
| 14100 | 12908 | 0.1% |
| 13980 | 62 | < 0.1% |
| Distinct | 2280 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 GiB |
| Today | 995486 |
|---|---|
| Good Morning America | 984661 |
| CBS This Morning | 835435 |
| NFL Football | 658048 |
| The Price Is Right | 629590 |
| Other values (2275) |
Length
| Max length | 88 |
|---|---|
| Median length | 17 |
| Mean length | 18.57564511 |
| Min length | 2 |
Characters and Unicode
| Total characters | 363853105 |
|---|---|
| Distinct characters | 86 |
| Distinct categories | 10 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Live with Kelly and Ryan |
|---|---|
| 2nd row | 60 Minutes |
| 3rd row | 60 Minutes |
| 4th row | CBS This Morning |
| 5th row | Unlocking Christmas |
Common Values
| Value | Count | Frequency (%) |
| Today | 995486 | 5.1% |
| Good Morning America | 984661 | 5.0% |
| CBS This Morning | 835435 | 4.3% |
| NFL Football | 658048 | 3.4% |
| The Price Is Right | 629590 | 3.2% |
| NBC Nightly News With Lester Holt | 570676 | 2.9% |
| ABC World News Tonight With David Muir | 439525 | 2.2% |
| The View | 438855 | 2.2% |
| The Bachelor | 376265 | 1.9% |
| GMA3: What You Need to Know | 334310 | 1.7% |
| Other values (2270) | 13324792 |
Length
| Value | Count | Frequency (%) |
| the | 4930148 | 7.6% |
| with | 2852281 | 4.4% |
| news | 2464772 | 3.8% |
| morning | 2415871 | 3.7% |
| today | 1693126 | 2.6% |
| cbs | 1508488 | 2.3% |
| america | 1142936 | 1.8% |
| good | 1123404 | 1.7% |
| this | 1044212 | 1.6% |
| and | 827932 | 1.3% |
| Other values (2395) | 45135661 |
Most occurring characters
| Value | Count | Frequency (%) |
| 45551188 | 12.5% | |
| e | 31193746 | 8.6% |
| o | 22640630 | 6.2% |
| i | 21625217 | 5.9% |
| a | 18639414 | 5.1% |
| n | 17648356 | 4.9% |
| t | 17348424 | 4.8% |
| r | 16750893 | 4.6% |
| h | 15137779 | 4.2% |
| s | 13452973 | 3.7% |
| Other values (76) | 143864485 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 238757393 | |
| Uppercase Letter | 71164856 | 19.6% |
| Space Separator | 45551188 | 12.5% |
| Decimal Number | 4388224 | 1.2% |
| Other Punctuation | 3723667 | 1.0% |
| Dash Punctuation | 179485 | < 0.1% |
| Other Symbol | 58243 | < 0.1% |
| Open Punctuation | 14163 | < 0.1% |
| Close Punctuation | 14163 | < 0.1% |
| Math Symbol | 1723 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 31193746 | |
| o | 22640630 | |
| i | 21625217 | |
| a | 18639414 | 7.8% |
| n | 17648356 | 7.4% |
| t | 17348424 | 7.3% |
| r | 16750893 | 7.0% |
| h | 15137779 | 6.3% |
| s | 13452973 | 5.6% |
| l | 12753670 | 5.3% |
| Other values (22) | 51566291 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 8415710 | |
| N | 6457566 | 9.1% |
| M | 5646786 | 7.9% |
| W | 5410778 | 7.6% |
| B | 5335092 | 7.5% |
| C | 5264265 | 7.4% |
| S | 4341494 | 6.1% |
| F | 4030206 | 5.7% |
| A | 3830564 | 5.4% |
| L | 2954771 | 4.2% |
| Other values (17) | 19477624 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 1410428 | |
| ' | 869698 | |
| . | 737844 | |
| & | 292251 | 7.8% |
| , | 191569 | 5.1% |
| ! | 183628 | 4.9% |
| / | 16296 | 0.4% |
| ¡ | 12060 | 0.3% |
| ? | 9390 | 0.3% |
| # | 483 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1037924 | |
| 3 | 911893 | |
| 6 | 597356 | |
| 1 | 530175 | |
| 5 | 362518 | 8.3% |
| 2 | 337593 | 7.7% |
| 4 | 313435 | 7.1% |
| 8 | 118999 | 2.7% |
| 7 | 108414 | 2.5% |
| 9 | 69917 | 1.6% |
Space Separator
| Value | Count | Frequency (%) |
| 45551188 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 179485 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 1723 |
Other Symbol
| Value | Count | Frequency (%) |
| � | 58243 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 14163 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 14163 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 309922249 | |
| Common | 53930856 | 14.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 31193746 | 10.1% |
| o | 22640630 | 7.3% |
| i | 21625217 | 7.0% |
| a | 18639414 | 6.0% |
| n | 17648356 | 5.7% |
| t | 17348424 | 5.6% |
| r | 16750893 | 5.4% |
| h | 15137779 | 4.9% |
| s | 13452973 | 4.3% |
| l | 12753670 | 4.1% |
| Other values (49) | 122731147 |
Common
| Value | Count | Frequency (%) |
| 45551188 | ||
| : | 1410428 | 2.6% |
| 0 | 1037924 | 1.9% |
| 3 | 911893 | 1.7% |
| ' | 869698 | 1.6% |
| . | 737844 | 1.4% |
| 6 | 597356 | 1.1% |
| 1 | 530175 | 1.0% |
| 5 | 362518 | 0.7% |
| 2 | 337593 | 0.6% |
| Other values (17) | 1584239 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 363705822 | |
| Latin 1 Sup | 89040 | < 0.1% |
| Specials | 58243 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 45551188 | 12.5% | |
| e | 31193746 | 8.6% |
| o | 22640630 | 6.2% |
| i | 21625217 | 5.9% |
| a | 18639414 | 5.1% |
| n | 17648356 | 4.9% |
| t | 17348424 | 4.8% |
| r | 16750893 | 4.6% |
| h | 15137779 | 4.2% |
| s | 13452973 | 3.7% |
| Other values (67) | 143717202 |
Specials
| Value | Count | Frequency (%) |
| � | 58243 |
Latin 1 Sup
| Value | Count | Frequency (%) |
| í | 26272 | |
| ó | 24650 | |
| é | 15190 | |
| ¡ | 12060 | |
| ñ | 4020 | 4.5% |
| ú | 3530 | 4.0% |
| á | 3167 | 3.6% |
| Á | 151 | 0.2% |
| Distinct | 2626 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 6763657 |
| Missing (%) | 34.5% |
| Memory size | 1.0 GiB |
| Chicago Bears at New Orleans Saints | 359053 |
|---|---|
| The Equalizer | 143541 |
| America's Game | 89179 |
| Indianapolis Colts at Buffalo Bills | 86058 |
| Other values (2621) |
Length
| Max length | 140 |
|---|---|
| Median length | 5 |
| Mean length | 11.53935953 |
| Min length | 0 |
Characters and Unicode
| Total characters | 147980585 |
|---|---|
| Distinct characters | 92 |
| Distinct categories | 12 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Live's Family Cooking Week |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
Common Values
| Value | Count | Frequency (%) |
| 6350029 | ||
| Chicago Bears at New Orleans Saints | 359053 | 1.8% |
| The Equalizer | 143541 | 0.7% |
| America's Game | 89179 | 0.5% |
| Indianapolis Colts at Buffalo Bills | 86058 | 0.4% |
| Baltimore Ravens at Tennessee Titans | 83705 | 0.4% |
| Cleveland Browns at Kansas City Chiefs | 74439 | 0.4% |
| Wheel Around the World | 60898 | 0.3% |
| Rail Tour | 58790 | 0.3% |
| Great Outdoors | 56794 | 0.3% |
| Other values (2616) | 5461500 | |
| (Missing) | 6763657 |
Length
| Value | Count | Frequency (%) |
| the | 1566853 | 6.1% |
| at | 859169 | 3.3% |
| 455481 | 1.8% | |
| and | 430605 | 1.7% |
| new | 415110 | 1.6% |
| of | 398984 | 1.5% |
| a | 371606 | 1.4% |
| chicago | 361889 | 1.4% |
| bears | 360197 | 1.4% |
| saints | 359756 | 1.4% |
| Other values (4394) | 20310488 |
Most occurring characters
| Value | Count | Frequency (%) |
| 19416181 | 13.1% | |
| e | 14173802 | 9.6% |
| a | 11270680 | 7.6% |
| n | 8361953 | 5.7% |
| o | 8108137 | 5.5% |
| i | 7756122 | 5.2% |
| t | 7733104 | 5.2% |
| r | 7129470 | 4.8% |
| s | 7087689 | 4.8% |
| l | 5563024 | 3.8% |
| Other values (82) | 51380423 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 102920686 | |
| Uppercase Letter | 21782896 | 14.7% |
| Space Separator | 19416181 | 13.1% |
| Other Punctuation | 2039621 | 1.4% |
| Decimal Number | 971949 | 0.7% |
| Math Symbol | 381289 | 0.3% |
| Dash Punctuation | 242539 | 0.2% |
| Open Punctuation | 103604 | 0.1% |
| Close Punctuation | 103604 | 0.1% |
| Other Symbol | 11806 | < 0.1% |
| Other values (2) | 6410 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 14173802 | |
| a | 11270680 | |
| n | 8361953 | 8.1% |
| o | 8108137 | 7.9% |
| i | 7756122 | 7.5% |
| t | 7733104 | 7.5% |
| r | 7129470 | 6.9% |
| s | 7087689 | 6.9% |
| l | 5563024 | 5.4% |
| h | 4277664 | 4.2% |
| Other values (23) | 21459041 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 2147082 | 9.9% |
| B | 1998254 | 9.2% |
| S | 1749402 | 8.0% |
| C | 1685683 | 7.7% |
| A | 1265881 | 5.8% |
| W | 1130347 | 5.2% |
| M | 1096630 | 5.0% |
| D | 1089135 | 5.0% |
| O | 948108 | 4.4% |
| P | 931523 | 4.3% |
| Other values (18) | 7740851 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 563083 | |
| , | 557362 | |
| . | 297943 | |
| : | 201697 | 9.9% |
| ? | 199184 | 9.8% |
| ; | 120305 | 5.9% |
| ! | 48092 | 2.4% |
| & | 29522 | 1.4% |
| " | 16262 | 0.8% |
| ¿ | 2622 | 0.1% |
| Other values (3) | 3549 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 215148 | |
| 2 | 181761 | |
| 1 | 146201 | |
| 4 | 143635 | |
| 5 | 115726 | |
| 3 | 49429 | 5.1% |
| 9 | 47693 | 4.9% |
| 6 | 41279 | 4.2% |
| 7 | 22614 | 2.3% |
| 8 | 8463 | 0.9% |
Space Separator
| Value | Count | Frequency (%) |
| 19416181 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 242539 |
Other Symbol
| Value | Count | Frequency (%) |
| � | 11806 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 2032 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 381289 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 4378 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 103604 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 103604 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 124703582 | |
| Common | 23277003 | 15.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 14173802 | 11.4% |
| a | 11270680 | 9.0% |
| n | 8361953 | 6.7% |
| o | 8108137 | 6.5% |
| i | 7756122 | 6.2% |
| t | 7733104 | 6.2% |
| r | 7129470 | 5.7% |
| s | 7087689 | 5.7% |
| l | 5563024 | 4.5% |
| h | 4277664 | 3.4% |
| Other values (51) | 43241937 |
Common
| Value | Count | Frequency (%) |
| 19416181 | ||
| ' | 563083 | 2.4% |
| , | 557362 | 2.4% |
| + | 381289 | 1.6% |
| . | 297943 | 1.3% |
| - | 242539 | 1.0% |
| 0 | 215148 | 0.9% |
| : | 201697 | 0.9% |
| ? | 199184 | 0.9% |
| 2 | 181761 | 0.8% |
| Other values (21) | 1020816 | 4.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 147910685 | |
| Latin 1 Sup | 58094 | < 0.1% |
| Specials | 11806 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 19416181 | 13.1% | |
| e | 14173802 | 9.6% |
| a | 11270680 | 7.6% |
| n | 8361953 | 5.7% |
| o | 8108137 | 5.5% |
| i | 7756122 | 5.2% |
| t | 7733104 | 5.2% |
| r | 7129470 | 4.8% |
| s | 7087689 | 4.8% |
| l | 5563024 | 3.8% |
| Other values (71) | 51310523 |
Specials
| Value | Count | Frequency (%) |
| � | 11806 |
Latin 1 Sup
| Value | Count | Frequency (%) |
| Å | 15082 | |
| ó | 10982 | |
| á | 8605 | |
| é | 7940 | |
| í | 6881 | |
| ñ | 4304 | 7.4% |
| ¿ | 2622 | 4.5% |
| ú | 1464 | 2.5% |
| Ú | 188 | 0.3% |
| ü | 26 | < 0.1% |
| Distinct | 50 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3089626 |
| Missing (%) | 15.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 805.091865 |
| Minimum | 0 |
|---|---|
| Maximum | 2021 |
| Zeros | 3544177 |
| Zeros (%) | 18.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 25 |
| Q3 | 2021 |
| 95-th percentile | 2021 |
| Maximum | 2021 |
| Range | 2021 |
| Interquartile range (IQR) | 2020 |
Descriptive statistics
| Standard deviation | 982.4743657 |
|---|---|
| Coefficient of variation (CV) | 1.220325789 |
| Kurtosis | -1.815126117 |
| Mean | 805.091865 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | 0.429016938 |
| Sum | 1.328241928 × 1010 |
| Variance | 965255.8793 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2021 | 5943460 | |
| 0 | 3544177 | |
| 1 | 871038 | 4.4% |
| 2 | 625031 | 3.2% |
| 2020 | 570360 | 2.9% |
| 49 | 515097 | 2.6% |
| 3 | 480214 | 2.5% |
| 5 | 388467 | 2.0% |
| 4 | 332332 | 1.7% |
| 38 | 288827 | 1.5% |
| Other values (40) | 2939014 | |
| (Missing) | 3089626 |
| Value | Count | Frequency (%) |
| 0 | 3544177 | |
| 1 | 871038 | 4.4% |
| 2 | 625031 | 3.2% |
| 3 | 480214 | 2.5% |
| 4 | 332332 | 1.7% |
| 5 | 388467 | 2.0% |
| 6 | 224710 | 1.1% |
| 7 | 122995 | 0.6% |
| 8 | 226133 | 1.2% |
| 9 | 170722 | 0.9% |
| Value | Count | Frequency (%) |
| 2021 | 5943460 | |
| 2020 | 570360 | 2.9% |
| 2017 | 479 | < 0.1% |
| 2016 | 1016 | < 0.1% |
| 2015 | 669 | < 0.1% |
| 2010 | 154 | < 0.1% |
| 1972 | 361 | < 0.1% |
| 191 | 5365 | < 0.1% |
| 179 | 1187 | < 0.1% |
| 161 | 14300 | 0.1% |
| Distinct | 216 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3089626 |
| Missing (%) | 15.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.80780533 |
| Minimum | 0 |
|---|---|
| Maximum | 1059 |
| Zeros | 3632098 |
| Zeros (%) | 18.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 11 |
| Q3 | 39 |
| 95-th percentile | 108 |
| Maximum | 1059 |
| Range | 1059 |
| Interquartile range (IQR) | 37 |
Descriptive statistics
| Standard deviation | 58.94310129 |
|---|---|
| Coefficient of variation (CV) | 1.8531018 |
| Kurtosis | 51.18598924 |
| Mean | 31.80780533 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 5.347993898 |
| Sum | 524765713 |
| Variance | 3474.28919 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3632098 | |
| 6 | 644135 | 3.3% |
| 3 | 569443 | 2.9% |
| 7 | 527024 | 2.7% |
| 2 | 499983 | 2.6% |
| 4 | 455878 | 2.3% |
| 1 | 439066 | 2.2% |
| 8 | 402038 | 2.1% |
| 5 | 373497 | 1.9% |
| 10 | 362769 | 1.9% |
| Other values (206) | 8592086 | |
| (Missing) | 3089626 | 15.8% |
| Value | Count | Frequency (%) |
| 0 | 3632098 | |
| 1 | 439066 | 2.2% |
| 2 | 499983 | 2.6% |
| 3 | 569443 | 2.9% |
| 4 | 455878 | 2.3% |
| 5 | 373497 | 1.9% |
| 6 | 644135 | 3.3% |
| 7 | 527024 | 2.7% |
| 8 | 402038 | 2.1% |
| 9 | 318196 | 1.6% |
| Value | Count | Frequency (%) |
| 1059 | 2623 | < 0.1% |
| 971 | 2669 | < 0.1% |
| 913 | 3023 | < 0.1% |
| 708 | 1499 | < 0.1% |
| 706 | 2716 | < 0.1% |
| 702 | 3553 | < 0.1% |
| 643 | 65 | < 0.1% |
| 413 | 4406 | < 0.1% |
| 402 | 31666 | |
| 361 | 4566 | < 0.1% |
| Distinct | 79 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 GiB |
| CBS | |
|---|---|
| ABC | |
| NBC | |
| FNC | |
| MSNBC | |
| Other values (74) |
Length
| Max length | 7 |
|---|---|
| Median length | 3 |
| Mean length | 3.240141093 |
| Min length | 1 |
Characters and Unicode
| Total characters | 63466727 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ABC |
|---|---|
| 2nd row | CBS |
| 3rd row | CBS |
| 4th row | CBS |
| 5th row | HMM |
Common Values
| Value | Count | Frequency (%) |
| CBS | 4864314 | |
| ABC | 4402122 | |
| NBC | 3524155 | |
| FNC | 844362 | 4.3% |
| MSNBC | 786768 | 4.0% |
| CNN | 523449 | 2.7% |
| HALL | 441158 | 2.3% |
| HMM | 304972 | 1.6% |
| TVLAND | 285180 | 1.5% |
| ESPN | 274399 | 1.4% |
| Other values (69) | 3336764 |
Length
| Value | Count | Frequency (%) |
| cbs | 4864314 | |
| abc | 4402122 | |
| nbc | 3524155 | |
| fnc | 844362 | 4.3% |
| msnbc | 786768 | 4.0% |
| cnn | 523449 | 2.7% |
| hall | 441158 | 2.3% |
| hmm | 304972 | 1.6% |
| tvland | 285180 | 1.5% |
| espn | 274399 | 1.4% |
| Other values (69) | 3336764 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 15600469 | |
| B | 13959239 | |
| N | 8008725 | |
| S | 6842377 | |
| A | 5686632 | 9.0% |
| L | 1590474 | 2.5% |
| F | 1542266 | 2.4% |
| M | 1512899 | 2.4% |
| H | 1251220 | 2.0% |
| T | 1145375 | 1.8% |
| Other values (15) | 6327051 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 63432176 | |
| Decimal Number | 34551 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 15600469 | |
| B | 13959239 | |
| N | 8008725 | |
| S | 6842377 | |
| A | 5686632 | 9.0% |
| L | 1590474 | 2.5% |
| F | 1542266 | 2.4% |
| M | 1512899 | 2.4% |
| H | 1251220 | 2.0% |
| T | 1145375 | 1.8% |
| Other values (13) | 6292500 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 34288 | |
| 1 | 263 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 63432176 | |
| Common | 34551 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 15600469 | |
| B | 13959239 | |
| N | 8008725 | |
| S | 6842377 | |
| A | 5686632 | 9.0% |
| L | 1590474 | 2.5% |
| F | 1542266 | 2.4% |
| M | 1512899 | 2.4% |
| H | 1251220 | 2.0% |
| T | 1145375 | 1.8% |
| Other values (13) | 6292500 |
Common
| Value | Count | Frequency (%) |
| 2 | 34288 | |
| 1 | 263 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 63466727 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 15600469 | |
| B | 13959239 | |
| N | 8008725 | |
| S | 6842377 | |
| A | 5686632 | 9.0% |
| L | 1590474 | 2.5% |
| F | 1542266 | 2.4% |
| M | 1512899 | 2.4% |
| H | 1251220 | 2.0% |
| T | 1145375 | 1.8% |
| Other values (15) | 6327051 |
| Distinct | 1274 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 GiB |
| FNC | 844362 |
|---|---|
| MSNBC | 786768 |
| CNN | 523449 |
| HALL | 441158 |
| WPVIDT | 362254 |
| Other values (1269) |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 5.210251432 |
| Min length | 1 |
Characters and Unicode
| Total characters | 102056545 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 9 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | WKOWDT |
|---|---|
| 2nd row | WISCDT |
| 3rd row | WISCDT |
| 4th row | WISCDT |
| 5th row | HMM |
Common Values
| Value | Count | Frequency (%) |
| FNC | 844362 | 4.3% |
| MSNBC | 786768 | 4.0% |
| CNN | 523449 | 2.7% |
| HALL | 441158 | 2.3% |
| WPVIDT | 362254 | 1.8% |
| HMM | 304972 | 1.6% |
| TVLAND | 285180 | 1.5% |
| WABCDT | 283264 | 1.4% |
| ESPN | 274399 | 1.4% |
| KABC | 264586 | 1.4% |
| Other values (1264) | 15217251 |
Length
| Value | Count | Frequency (%) |
| fnc | 844362 | 4.3% |
| msnbc | 786768 | 4.0% |
| cnn | 523449 | 2.7% |
| hall | 441158 | 2.3% |
| wpvidt | 362254 | 1.8% |
| hmm | 304972 | 1.6% |
| tvland | 285180 | 1.5% |
| wabcdt | 283264 | 1.4% |
| espn | 274399 | 1.4% |
| kabc | 264586 | 1.4% |
| Other values (1264) | 15217251 |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 17501705 | |
| D | 14570549 | |
| W | 9290552 | 9.1% |
| C | 6216847 | 6.1% |
| K | 6022124 | 5.9% |
| N | 5909896 | 5.8% |
| A | 4527508 | 4.4% |
| S | 4318723 | 4.2% |
| B | 4150486 | 4.1% |
| V | 3274211 | 3.2% |
| Other values (21) | 26273944 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 101943614 | |
| Decimal Number | 112931 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 17501705 | |
| D | 14570549 | |
| W | 9290552 | 9.1% |
| C | 6216847 | 6.1% |
| K | 6022124 | 5.9% |
| N | 5909896 | 5.8% |
| A | 4527508 | 4.4% |
| S | 4318723 | 4.2% |
| B | 4150486 | 4.1% |
| V | 3274211 | 3.2% |
| Other values (16) | 26161013 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 106422 | |
| 3 | 4772 | 4.2% |
| 1 | 959 | 0.8% |
| 5 | 696 | 0.6% |
| 4 | 82 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 101943614 | |
| Common | 112931 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 17501705 | |
| D | 14570549 | |
| W | 9290552 | 9.1% |
| C | 6216847 | 6.1% |
| K | 6022124 | 5.9% |
| N | 5909896 | 5.8% |
| A | 4527508 | 4.4% |
| S | 4318723 | 4.2% |
| B | 4150486 | 4.1% |
| V | 3274211 | 3.2% |
| Other values (16) | 26161013 |
Common
| Value | Count | Frequency (%) |
| 2 | 106422 | |
| 3 | 4772 | 4.2% |
| 1 | 959 | 0.8% |
| 5 | 696 | 0.6% |
| 4 | 82 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 102056545 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 17501705 | |
| D | 14570549 | |
| W | 9290552 | 9.1% |
| C | 6216847 | 6.1% |
| K | 6022124 | 5.9% |
| N | 5909896 | 5.8% |
| A | 4527508 | 4.4% |
| S | 4318723 | 4.2% |
| B | 4150486 | 4.1% |
| V | 3274211 | 3.2% |
| Other values (21) | 26273944 |
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1307 |
| Missing (%) | < 0.1% |
| Memory size | 1.3 GiB |
| ViacomCBS | |
|---|---|
| NBCUniversal | |
| Disney Media Networks | |
| Fox | |
| Discovery | |
| Other values (17) |
Length
| Max length | 45 |
|---|---|
| Median length | 12 |
| Mean length | 13.45425178 |
| Min length | 3 |
Characters and Unicode
| Total characters | 263519496 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Disney Media Networks |
|---|---|
| 2nd row | ViacomCBS |
| 3rd row | ViacomCBS |
| 4th row | ViacomCBS |
| 5th row | CrownMedia Family Network |
Common Values
| Value | Count | Frequency (%) |
| ViacomCBS | 5217338 | |
| NBCUniversal | 4942880 | |
| Disney Media Networks | 4871038 | |
| Fox | 1163081 | 5.9% |
| Discovery | 874298 | 4.5% |
| WarnerMedia | 803536 | 4.1% |
| CrownMedia Family Network | 746130 | 3.8% |
| A+E Networks | 252531 | 1.3% |
| Univision Communications | 175185 | 0.9% |
| Sony Pictures | 137178 | 0.7% |
| Other values (12) | 403141 | 2.1% |
Length
| Value | Count | Frequency (%) |
| viacomcbs | 5258758 | |
| networks | 5169218 | |
| media | 5059493 | |
| nbcuniversal | 4942880 | |
| disney | 4871038 | |
| fox | 1163081 | 3.6% |
| discovery | 874298 | 2.7% |
| warnermedia | 845060 | 2.6% |
| network | 746130 | 2.3% |
| family | 746130 | 2.3% |
| Other values (28) | 2328423 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 24771097 | 9.4% |
| e | 24524434 | 9.3% |
| a | 18875695 | 7.2% |
| s | 16683025 | 6.3% |
| o | 14891004 | 5.7% |
| r | 14766910 | 5.6% |
| n | 12740885 | 4.8% |
| 12418173 | 4.7% | |
| C | 11172427 | 4.2% |
| N | 10934129 | 4.1% |
| Other values (36) | 101741717 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 186104639 | |
| Uppercase Letter | 64547664 | 24.5% |
| Space Separator | 12418173 | 4.7% |
| Math Symbol | 252531 | 0.1% |
| Other Punctuation | 196489 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 24771097 | |
| e | 24524434 | |
| a | 18875695 | |
| s | 16683025 | |
| o | 14891004 | 8.0% |
| r | 14766910 | 7.9% |
| n | 12740885 | 6.8% |
| d | 6687779 | 3.6% |
| w | 6661478 | 3.6% |
| y | 6628644 | 3.6% |
| Other values (12) | 38873688 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 11172427 | |
| N | 10934129 | |
| B | 10201742 | |
| M | 6807269 | |
| D | 5745336 | |
| S | 5395936 | |
| V | 5258758 | |
| U | 5130589 | |
| F | 1909438 | 3.0% |
| W | 848602 | 1.3% |
| Other values (9) | 1143438 | 1.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 79395 | |
| . | 75570 | |
| & | 41524 |
Space Separator
| Value | Count | Frequency (%) |
| 12418173 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 252531 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 250652303 | |
| Common | 12867193 | 4.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 24771097 | 9.9% |
| e | 24524434 | 9.8% |
| a | 18875695 | 7.5% |
| s | 16683025 | 6.7% |
| o | 14891004 | 5.9% |
| r | 14766910 | 5.9% |
| n | 12740885 | 5.1% |
| C | 11172427 | 4.5% |
| N | 10934129 | 4.4% |
| B | 10201742 | 4.1% |
| Other values (31) | 91090955 |
Common
| Value | Count | Frequency (%) |
| 12418173 | ||
| + | 252531 | 2.0% |
| , | 79395 | 0.6% |
| . | 75570 | 0.6% |
| & | 41524 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 263519496 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 24771097 | 9.4% |
| e | 24524434 | 9.3% |
| a | 18875695 | 7.2% |
| s | 16683025 | 6.3% |
| o | 14891004 | 5.7% |
| r | 14766910 | 5.6% |
| n | 12740885 | 4.8% |
| 12418173 | 4.7% | |
| C | 11172427 | 4.2% |
| N | 10934129 | 4.1% |
| Other values (36) | 101741717 |
| Distinct | 210 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 155931 |
| Missing (%) | 0.8% |
| Memory size | 1.4 GiB |
| New York NY | 972744 |
|---|---|
| Los Angeles CA | 911697 |
| Philadelphia PA | 889464 |
| Tampa-St.Petersburg-Sarasota FL | 636715 |
| Dallas-Ft.Worth TX | 612316 |
| Other values (205) |
Length
| Max length | 50 |
|---|---|
| Median length | 17 |
| Mean length | 19.32345241 |
| Min length | 7 |
Characters and Unicode
| Total characters | 375487762 |
|---|---|
| Distinct characters | 54 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Madison WI |
|---|---|
| 2nd row | Madison WI |
| 3rd row | Madison WI |
| 4th row | Madison WI |
| 5th row | Davenport IA-Rock Island-Moline IL |
Common Values
| Value | Count | Frequency (%) |
| New York NY | 972744 | 5.0% |
| Los Angeles CA | 911697 | 4.7% |
| Philadelphia PA | 889464 | 4.5% |
| Tampa-St.Petersburg-Sarasota FL | 636715 | 3.3% |
| Dallas-Ft.Worth TX | 612316 | 3.1% |
| Chicago IL | 560245 | 2.9% |
| Pittsburgh PA | 469644 | 2.4% |
| Boston MA-Manchester NH | 359332 | 1.8% |
| Wilkes Barre-Scranton PA | 338919 | 1.7% |
| Washington DC-Hagerstown MD | 327235 | 1.7% |
| Other values (200) | 13353401 |
Length
| Value | Count | Frequency (%) |
| pa | 2009674 | 4.0% |
| tx | 1792871 | 3.6% |
| ca | 1624272 | 3.2% |
| fl | 1526065 | 3.0% |
| ny | 1269825 | 2.5% |
| il | 1066093 | 2.1% |
| new | 1059918 | 2.1% |
| york | 972744 | 1.9% |
| angeles | 911697 | 1.8% |
| los | 911697 | 1.8% |
| Other values (330) | 36989320 |
Most occurring characters
| Value | Count | Frequency (%) |
| 30702464 | 8.2% | |
| a | 28410452 | 7.6% |
| e | 25964054 | 6.9% |
| o | 22309364 | 5.9% |
| t | 19113629 | 5.1% |
| n | 19011524 | 5.1% |
| l | 17220613 | 4.6% |
| r | 16674771 | 4.4% |
| i | 15883602 | 4.2% |
| s | 15590032 | 4.2% |
| Other values (44) | 164607257 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 240524898 | |
| Uppercase Letter | 87400374 | 23.3% |
| Space Separator | 30702464 | 8.2% |
| Dash Punctuation | 14527193 | 3.9% |
| Other Punctuation | 2332833 | 0.6% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 10793241 | 12.3% |
| C | 7272601 | 8.3% |
| P | 6305909 | 7.2% |
| L | 5992947 | 6.9% |
| N | 5970770 | 6.8% |
| S | 5926216 | 6.8% |
| M | 5752028 | 6.6% |
| T | 4359251 | 5.0% |
| D | 4055092 | 4.6% |
| F | 3958746 | 4.5% |
| Other values (16) | 27013573 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 28410452 | |
| e | 25964054 | |
| o | 22309364 | |
| t | 19113629 | 7.9% |
| n | 19011524 | 7.9% |
| l | 17220613 | 7.2% |
| r | 16674771 | 6.9% |
| i | 15883602 | 6.6% |
| s | 15590032 | 6.5% |
| h | 8124542 | 3.4% |
| Other values (15) | 52222315 |
Space Separator
| Value | Count | Frequency (%) |
| 30702464 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 14527193 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 2332833 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 327925272 | |
| Common | 47562490 | 12.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 28410452 | 8.7% |
| e | 25964054 | 7.9% |
| o | 22309364 | 6.8% |
| t | 19113629 | 5.8% |
| n | 19011524 | 5.8% |
| l | 17220613 | 5.3% |
| r | 16674771 | 5.1% |
| i | 15883602 | 4.8% |
| s | 15590032 | 4.8% |
| A | 10793241 | 3.3% |
| Other values (41) | 136953990 |
Common
| Value | Count | Frequency (%) |
| 30702464 | ||
| - | 14527193 | |
| . | 2332833 | 4.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 375487762 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 30702464 | 8.2% | |
| a | 28410452 | 7.6% |
| e | 25964054 | 6.9% |
| o | 22309364 | 5.9% |
| t | 19113629 | 5.1% |
| n | 19011524 | 5.1% |
| l | 17220613 | 4.6% |
| r | 16674771 | 4.4% |
| i | 15883602 | 4.2% |
| s | 15590032 | 4.2% |
| Other values (44) | 164607257 |
| Distinct | 378563 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10276.06117 |
| Minimum | 0 |
|---|---|
| Maximum | 775446 |
| Zeros | 13628575 |
| Zeros (%) | 69.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 40192 |
| Maximum | 775446 |
| Range | 775446 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 54416.53292 |
|---|---|
| Coefficient of variation (CV) | 5.295466035 |
| Kurtosis | 65.23500301 |
| Mean | 10276.06117 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.564721294 |
| Sum | 2.012838177 × 1011 |
| Variance | 2961159055 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 13628575 | |
| 1 | 1983203 | 10.1% |
| 2 | 413121 | 2.1% |
| 3 | 87483 | 0.4% |
| 1795 | 50500 | 0.3% |
| 1794 | 32327 | 0.2% |
| 4 | 25524 | 0.1% |
| 1796 | 19623 | 0.1% |
| 5 | 14361 | 0.1% |
| 1793 | 11794 | 0.1% |
| Other values (378553) | 3321132 | 17.0% |
| Value | Count | Frequency (%) |
| 0 | 13628575 | |
| 1 | 1983203 | 10.1% |
| 2 | 413121 | 2.1% |
| 3 | 87483 | 0.4% |
| 4 | 25524 | 0.1% |
| 5 | 14361 | 0.1% |
| 6 | 9136 | < 0.1% |
| 7 | 7055 | < 0.1% |
| 8 | 8007 | < 0.1% |
| 9 | 6983 | < 0.1% |
| Value | Count | Frequency (%) |
| 775446 | 1 | |
| 775425 | 1 | |
| 775334 | 1 | |
| 775115 | 1 | |
| 774867 | 1 | |
| 774828 | 1 | |
| 774634 | 1 | |
| 774454 | 1 | |
| 774142 | 1 | |
| 774075 | 1 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 GiB |
| live | |
|---|---|
| liveplussd | |
| liveplus3 | 361989 |
| liveplus7 | 230292 |
| all | 19032 |
Length
| Max length | 10 |
|---|---|
| Median length | 4 |
| Mean length | 5.788316389 |
| Min length | 3 |
Characters and Unicode
| Total characters | 113379475 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | live |
|---|---|
| 2nd row | live |
| 3rd row | live |
| 4th row | live |
| 5th row | liveplussd |
Common Values
| Value | Count | Frequency (%) |
| live | 13628575 | |
| liveplussd | 5347755 | 27.3% |
| liveplus3 | 361989 | 1.8% |
| liveplus7 | 230292 | 1.2% |
| all | 19032 | 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| live | 13628575 | |
| liveplussd | 5347755 | 27.3% |
| liveplus3 | 361989 | 1.8% |
| liveplus7 | 230292 | 1.2% |
| all | 19032 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 25546711 | |
| i | 19568611 | |
| v | 19568611 | |
| e | 19568611 | |
| s | 11287791 | |
| p | 5940036 | 5.2% |
| u | 5940036 | 5.2% |
| d | 5347755 | 4.7% |
| 3 | 361989 | 0.3% |
| 7 | 230292 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 112787194 | |
| Decimal Number | 592281 | 0.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 25546711 | |
| i | 19568611 | |
| v | 19568611 | |
| e | 19568611 | |
| s | 11287791 | |
| p | 5940036 | 5.3% |
| u | 5940036 | 5.3% |
| d | 5347755 | 4.7% |
| a | 19032 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 361989 | |
| 7 | 230292 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 112787194 | |
| Common | 592281 | 0.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 25546711 | |
| i | 19568611 | |
| v | 19568611 | |
| e | 19568611 | |
| s | 11287791 | |
| p | 5940036 | 5.3% |
| u | 5940036 | 5.3% |
| d | 5347755 | 4.7% |
| a | 19032 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| 3 | 361989 | |
| 7 | 230292 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 113379475 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 25546711 | |
| i | 19568611 | |
| v | 19568611 | |
| e | 19568611 | |
| s | 11287791 | |
| p | 5940036 | 5.2% |
| u | 5940036 | 5.2% |
| d | 5347755 | 4.7% |
| 3 | 361989 | 0.3% |
| 7 | 230292 | 0.2% |
| Distinct | 76 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -959.806914 |
| Minimum | -61560 |
|---|---|
| Maximum | 36000 |
| Zeros | 16423654 |
| Zeros (%) | 83.8% |
| Negative | 2954226 |
| Negative (%) | 15.1% |
| Memory size | 149.4 MiB |
Quantile statistics
| Minimum | -61560 |
|---|---|
| 5-th percentile | -7200 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 36000 |
| Range | 97560 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2861.018559 |
|---|---|
| Coefficient of variation (CV) | -2.980827204 |
| Kurtosis | 22.6440384 |
| Mean | -959.806914 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -3.741991089 |
| Sum | -1.880035518 × 1010 |
| Variance | 8185427.197 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 16423654 | |
| -3600 | 1520890 | 7.8% |
| -10800 | 842596 | 4.3% |
| -7200 | 437266 | 2.2% |
| 1800 | 136889 | 0.7% |
| -1800 | 45691 | 0.2% |
| 7200 | 37919 | 0.2% |
| 3600 | 34899 | 0.2% |
| -14400 | 30789 | 0.2% |
| -5400 | 19587 | 0.1% |
| Other values (66) | 57463 | 0.3% |
| Value | Count | Frequency (%) |
| -61560 | 2 | < 0.1% |
| -60000 | 12 | < 0.1% |
| -59400 | 2 | < 0.1% |
| -57720 | 20 | < 0.1% |
| -47220 | 28 | < 0.1% |
| -45420 | 96 | < 0.1% |
| -45360 | 896 | |
| -39960 | 71 | < 0.1% |
| -39600 | 57 | < 0.1% |
| -38160 | 1003 |
| Value | Count | Frequency (%) |
| 36000 | 11 | < 0.1% |
| 32400 | 45 | < 0.1% |
| 7200 | 37919 | 0.2% |
| 3600 | 34899 | 0.2% |
| 1800 | 136889 | 0.7% |
| 0 | 16423654 | |
| -60 | 47 | < 0.1% |
| -1800 | 45691 | 0.2% |
| -2400 | 2486 | < 0.1% |
| -3600 | 1520890 | 7.8% |
| Distinct | 2938708 |
|---|---|
| Distinct (%) | 15.9% |
| Missing | 1135274 |
| Missing (%) | 5.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.45272316 |
| Minimum | 1 |
|---|---|
| Maximum | 811.523236 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2.799529122 |
| median | 23.05207007 |
| Q3 | 41.45007106 |
| 95-th percentile | 75.8737457 |
| Maximum | 811.523236 |
| Range | 810.523236 |
| Interquartile range (IQR) | 38.65054194 |
Descriptive statistics
| Standard deviation | 26.13403377 |
|---|---|
| Coefficient of variation (CV) | 0.9519650789 |
| Kurtosis | 4.464549806 |
| Mean | 27.45272316 |
| Median Absolute Deviation (MAD) | 19.26623718 |
| Skewness | 1.43345578 |
| Sum | 506567777.8 |
| Variance | 682.987721 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 4313201 | 22.0% |
| 25.09884225 | 326 | < 0.1% |
| 40.66802436 | 320 | < 0.1% |
| 8.935577927 | 294 | < 0.1% |
| 6.930976876 | 289 | < 0.1% |
| 72.01626038 | 289 | < 0.1% |
| 127.7255278 | 283 | < 0.1% |
| 20.22227751 | 281 | < 0.1% |
| 27.69559947 | 267 | < 0.1% |
| 65.24259306 | 257 | < 0.1% |
| Other values (2938698) | 14136562 | |
| (Missing) | 1135274 | 5.8% |
| Value | Count | Frequency (%) |
| 1 | 4313201 | |
| 1.000013313 | 3 | < 0.1% |
| 1.000070003 | 3 | < 0.1% |
| 1.000073434 | 2 | < 0.1% |
| 1.000102342 | 3 | < 0.1% |
| 1.000110199 | 1 | < 0.1% |
| 1.000132986 | 4 | < 0.1% |
| 1.000138516 | 10 | < 0.1% |
| 1.000151342 | 1 | < 0.1% |
| 1.000158171 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 811.523236 | 23 | < 0.1% |
| 394.2478257 | 65 | |
| 376.5925023 | 26 | < 0.1% |
| 347.843469 | 59 | |
| 318.6505974 | 2 | < 0.1% |
| 313.9073484 | 33 | |
| 311.0420845 | 6 | < 0.1% |
| 288.0964255 | 7 | < 0.1% |
| 283.5585502 | 40 | |
| 279.9493643 | 11 | < 0.1% |
| Distinct | 2941195 |
|---|---|
| Distinct (%) | 15.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.4 MiB |
| Minimum | 2020-12-13 14:00:00 |
|---|---|
| Maximum | 2021-03-21 21:37:38 |
| Distinct | 2385758 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.4 MiB |
| Minimum | 2020-12-13 14:59:59 |
|---|---|
| Maximum | 2021-03-21 23:59:52 |